1 UPDATE `mig_db`.`lib_template` SET `tags` = 'first_name,family_name,vehicle,seller,price,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email,stock_number,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email', `email_template` = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
5 <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
8 <body style="padding:0;margin:0;">
9 <!-- Begin 100% Wrapping Table -->
10 <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
12 <td style="padding:20px 0;">
13 <!-- Begin Main Template Table -->
14 <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">
17 <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
21 <td style="background:#f6f6f6;padding:20px 0">
22 <!-- Main Content table -->
23 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
25 <!-- Spacing Column -->
26 <td width="20" valign="top" style="width:20px;"> </td>
28 <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
29 <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Bid Successful</h1>
30 <p style="margin:0 0 1em;padding:0;">
33 <p style="margin:0 0 1em;padding:0;">
34 Dear [first_name] [family_name],
36 <p style="margin:0 0 1em;padding:0;">
37 Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].
39 <p style="margin:0 0 1em;padding:0;">
40 <b>Your responsibilities:</b>
42 <li>Complete sale within two working days.</li>
43 <li>Collect vehicle.</li>
44 <li>Sign attachments when collecting vehicle.</li>
47 <p style="margin:0 0 1em;padding:0;">
49 <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
51 <td width="80px"><b>Trading Name:</b></td>
52 <td><b>[seller]</b></td>
55 <td width="80px"><b>Full Name:</b></td>
56 <td><b>[seller_name]</b></td>
59 <td width="80px"><b>Auction Address:</b></td>
60 <td><b>[vehicle_address]</b></td>
63 <td width="80px"><b>Billing Address:</b></td>
64 <td><b>[seller_billing_address]</b></td>
67 <td width="80px"><b>VAT Number:</b></td>
68 <td><b>[seller_vat_number]</b></td>
71 <td width="80px"><b>E-mail:</b></td>
72 <td><b>[seller_email]</b></td>
75 <td width="80px"><b>Stock Number:</b></td>
76 <td><b>[stock_number]</b></td>
83 <p style="margin:0 0 1em;padding:0;">
85 <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
87 <td width="80px"><b>Trading Name:</b></td>
88 <td><b>[buyer]</b></td>
91 <td width="80px"><b>Full Name:</b></td>
92 <td><b>[buyer_name]</b></td>
95 <td width="80px"><b>Physical Address:</b></td>
96 <td><b>[buyer_address]</b></td>
99 <td width="80px"><b>VAT Number:</b></td>
100 <td><b>[buyer_vat_number]</b></td>
103 <td width="80px"><b>Cellphone:</b></td>
104 <td><b>[buyer_mobile]</b></td>
107 <td width="80px"><b>E-mail:</b></td>
108 <td><b>[buyer_email]</b></td>
114 <p style="margin:0 0 1em;padding:0;"><br/>
119 <!-- Spacing Column -->
120 <td width="40" valign="top" style="width:40px;"> </td>
122 <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
123 <img src="{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />
124 <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>
125 <p style="margin:0 0 1em;padding:5px;">
126 Online technology bringing buyers and sellers
127 together through the Dealer Network.
130 <!-- Spacing Column -->
131 <td width="20" valign="top" style="width:20px;"> </td>
134 <!-- /Main Content Table -->
138 <td style="background:#ececec;padding:10px 0 0;">
139 <!-- Begin Footer table -->
140 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">
142 <!-- Spacing Column -->
143 <td width="20" valign="top" style="width:20px;"> </td>
145 <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">
146 <p style="margin:0 0 1em;padding:0;"><b>demo.bid4cars.co.za</b></p>
148 <!-- Spacing Column -->
149 <td width="20" valign="top" style="width:20px;"> </td>
152 <!-- /End Footer Table -->
156 <!-- /End Main Template Table -->
160 <!-- /End 100% Wrapping Table -->
163 ' WHERE `lib_template`.`id` = 5;